package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.Checkitem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CheckitemMapper extends BaseMapper<Checkitem> {

    @Select("select ci.* from checkgroupitem_t ct left join checkitem_t ci on ct.item_id = ci.id where ct.group_id = #{id}")
    List<Checkitem> findItemsBygId(@Param("id") Long id);
}
